﻿/***********************************************************************************************************************************
 *    Name: DBInventory.sql
 *  Author: Frank Figearo — http://www.sqlnerd.me/ — frank@sqlnerd.me
 * Summary: 
**/
SELECT  name,
        compatibility_level,
        state_desc,
        recovery_model_desc,
        page_verify_option_desc,
        is_fulltext_enabled,
        is_published,
        is_subscribed,
        is_merge_published,
        is_distributor
FROM    sys.databases
WHERE   4 < database_id;
GO